SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 672683 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 672683 [ RunTime:0.002305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694110,68110,1001035,12674,278355,765986,292911,397199,901038,788938,947888,73977,461104,1012357,150522,582819,967395,451572,1047402,67285,430006,399463,470216,150733,15607,2520,812874,105400,365195,742898,876345,2031,685269,754163,270529,944739,321939,727482,280291,9826,501634,576472,1017410,871180,659121,453210,819081,49043,310467,705966,909726,810048,190536,403830,483913,66383,299423,193572,207386,392629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 672683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 672683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]