SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 224380 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 224380 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472094,102289,260129,572197,712856,932226,308371,122647,119913,903157,311778,1020127,853443,965099,977249,203505,560824,757813,661671,647360,418290,158343,33584,914237,200287,480359,878600,222698,828881,295331,112879,882119,659612,1033577,162305,275238,919117,843514,1031727,71628,922020,984314,907747,799845,468664,577309,1024079,945190,461121,746430,914872,337505,72839,358934,554085,336315,78262,454034,355508,574271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 224380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 224380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]