SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001964s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50476 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50476 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295282,55816,1045855,751962,940490,899,12241,143285,956938,397246,200756,472091,422783,977781,7188,393292,549348,417518,13974,339103,666404,444949,952311,620477,559248,631757,857269,357822,202524,757996,1004022,795938,104859,191801,657660,1001012,188671,608759,992238,483324,517680,178429,736697,345435,763824,775175,490766,632677,1011168,721735,893877,106769,743032,778469,998740,191552,748162,1018841,900892,170686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]