SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 72018 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 72018 [ RunTime:0.002903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3289,1000870,678935,780372,433841,148916,828787,48771,498413,241022,774041,284265,576949,634672,825796,777696,211521,237905,745290,912584,806255,89048,1013524,469393,484093,76072,604607,816078,661762,1042344,95047,566995,984280,10250,282598,890817,281806,778596,963211,579482,422627,387962,1007615,540141,928186,607061,1037459,992786,329344,914529,466571,1030318,832587,485701,658658,269268,662612,434731,125287,1027748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 72018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 72018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]