SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46839 LIMIT 1 [ RunTime:0.002774s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46839 [ RunTime:0.002420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133434,727693,1044822,398001,187775,169612,627590,207432,574260,213444,191519,1000315,264430,162214,85691,841672,50424,152667,751796,265500,215012,460034,221332,216199,979609,323891,627618,848114,167429,728614,497143,958500,997307,319743,875800,340916,230281,1016479,487165,255222,404018,296494,692096,126032,147124,673511,369152,638916,982283,629737,294800,759767,1009177,148496,708509,605065,372187,135400,610150,917090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]