SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017478 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017478 [ RunTime:0.002889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582182,502663,21110,890915,29036,492340,355749,145702,345543,732508,252831,222585,432597,261814,235708,956427,235824,959599,934195,91980,397234,70273,707657,181158,92865,422461,22045,979315,866456,380686,332948,82050,747899,788506,9559,195142,351701,969950,1039342,86654,673388,85595,726886,1038221,337125,401984,338427,1021617,42680,252449,442129,567282,721560,339969,465986,190900,1006881,498653,563472,765402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001644s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]