SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420568 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420568 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (908353,775368,285565,18011,220659,406090,5455,218854,557693,1040021,974665,634560,182500,278884,14682,815139,14414,742467,973720,310646,303710,754096,849362,328251,1006798,513878,681081,650421,658507,224974,775726,90835,1043939,862592,935146,1028754,349929,896927,360161,57689,241108,1019716,840616,761074,654305,39072,646121,610877,476509,587890,299270,1025544,80227,280500,178901,1039759,560421,380628,603447,566062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]