SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266511 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266511 [ RunTime:0.003354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664643,235460,161018,178047,319044,1008624,1042684,390517,940267,730972,16469,309489,124421,18528,214430,30714,89900,434158,996314,286386,283035,627503,277996,649177,381652,259521,90142,131509,396857,493948,833048,401832,81325,887902,82125,474485,1019029,513844,301527,59099,420867,50642,720983,802290,164497,641673,374120,24630,684602,410168,778342,370705,509203,940705,434468,299930,658399,402834,203638,667319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]