SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003012s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308118 LIMIT 1 [ RunTime:0.000983s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308118 [ RunTime:0.003985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608806,47359,117454,911671,434047,381405,313600,103626,601510,147853,42304,424026,781015,559570,455503,344301,35586,836660,616725,1040055,432932,841652,405422,2852,616018,302216,85892,488446,549854,403048,498553,62443,460684,846662,143786,443769,970458,1012530,832872,1011625,538909,25138,679591,274472,658106,570333,892012,592747,800718,493282,1044816,735725,150824,462073,2301,280488,625455,970470,630708,716425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001340s ]