SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 76113 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 76113 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514755,106163,91673,918528,81857,371141,198587,278628,464300,720872,751878,298150,1004293,1018539,959205,629135,997566,1018896,957110,310209,1031674,584755,1028019,406935,958853,444638,934358,240076,983382,329131,674525,152649,741584,59824,872685,789949,655218,1012081,508005,913064,294471,1033630,1024013,619809,466051,400831,992112,766536,763623,638115,1029322,566759,732934,741928,111948,1016532,100171,283524,211576,787256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 76113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 76113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]