SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503484 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503484 [ RunTime:0.002847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425187,1044722,925291,165846,330087,512222,386276,857707,725444,884705,40567,359273,878287,275007,422057,724277,110238,657803,393848,389624,220951,75137,113776,590614,359240,749998,680776,335838,642912,479888,665998,250743,27235,952207,501189,521071,247177,892095,433535,823216,1036914,24214,703574,914091,652932,634773,486317,984296,319111,649179,721530,636168,996631,953643,132993,979295,531880,678243,708948,172934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]