SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102075 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102075 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110307,748689,842542,52443,1024427,534250,564728,775276,970010,773877,15814,967125,843832,30054,457776,143993,757729,344744,425432,209235,102617,772588,772331,544849,369886,600049,985797,203209,23091,144666,114257,701579,55939,912607,960127,149857,943250,729617,778634,901964,799425,934507,768342,781266,816386,829749,508966,810569,447758,1012781,187264,806814,712467,42564,986474,143496,128904,249943,275791,780837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]