SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542839 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542839 [ RunTime:0.005296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248820,376630,334245,403217,262297,780626,112960,930792,473394,695035,301656,306911,891769,211399,332956,119670,916709,515251,663798,241243,812405,504349,498583,319624,234473,234190,247675,648909,746466,182376,1032554,666546,154410,180900,631254,515391,663539,371600,864835,204232,25680,997568,412585,78259,514374,461692,52400,640593,883548,539422,189583,154278,870200,843519,471743,12681,974272,556515,798596,637615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001829s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002220s ]