SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026571 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026571 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720165,1047364,865295,762515,578638,363226,628200,637951,552038,24379,399563,982792,528738,594481,520256,645068,9778,487875,413338,148192,137426,297292,600046,991871,294104,1024988,358095,365537,293364,314718,625546,593631,1044366,736856,375036,303067,7316,343721,961046,817929,980354,88030,706982,175956,225300,71311,29606,562440,935863,694325,910861,656072,703983,762360,557126,281187,317308,379787,245158,151012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016867s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002515s ]