SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265818 LIMIT 1 [ RunTime:0.000939s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265818 [ RunTime:0.002078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434000,174705,860897,743750,724893,903793,527433,631191,353897,220523,775278,189251,279956,673535,730067,636999,844414,589091,204694,619517,646931,299899,364880,943787,696611,751773,559728,369088,900830,371595,870920,919244,128407,806702,55395,911404,740994,7866,346796,535927,631217,27632,26535,391248,419101,460786,278493,77733,789289,381031,794128,613550,319061,35912,520073,597778,644163,408936,467644,622695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]