SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021211 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021211 [ RunTime:0.002132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041868,915442,1038425,558800,382821,473432,583546,905774,3787,351786,56510,324786,341005,912534,939060,568821,186681,453147,270714,791017,450463,623164,974533,985971,150906,12731,991796,284730,777594,969049,200506,211872,101556,843055,286326,991874,992027,78415,969813,142988,996604,3651,991583,952654,764014,985830,154993,762501,390197,358799,757914,31100,682091,57099,649219,1016342,236660,148316,242948,184727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]