SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329613 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329613 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983104,205900,286892,755822,470565,144733,970321,827394,520540,389036,751718,18078,582592,187242,901350,261151,827357,365370,200587,338022,388076,765624,460809,925124,413075,113932,340236,6974,527627,403286,75400,609457,401851,1020856,529819,531904,866492,86314,737309,453356,62659,1013583,36134,727133,638414,498838,23387,118308,883099,1011276,240815,789435,975228,835619,426438,710670,739376,981639,582751,416994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]