SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001473 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001473 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743525,674390,318436,1012369,522089,918161,1207,970790,601096,633308,1041713,760505,291361,574421,109343,418600,575575,257067,625162,852706,835018,974309,365157,252634,793800,632826,450805,210788,433119,190263,627767,469474,498013,122434,701401,401157,343271,408599,740629,805237,830651,542669,305101,683057,870098,352393,293994,1000600,979564,632024,501540,732239,903740,848886,169081,722114,823951,164795,241371,4504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]