SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524611 LIMIT 1 [ RunTime:0.000847s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524611 [ RunTime:0.003829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32272,236411,542740,6626,477253,60853,752987,746652,889842,766277,543260,486876,329503,685335,643792,687024,514551,677786,189877,34965,724275,390992,344257,213365,936597,141146,969814,149616,520175,962222,871832,96484,778603,454244,261633,523098,652473,913495,901140,850628,1045212,913286,358989,949118,838328,995441,627027,420500,680785,835599,372361,579240,629819,552071,533115,438624,84273,756600,561568,159034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]