SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425639 LIMIT 1 [ RunTime:0.000659s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425639 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630107,149983,1033256,242134,314447,250556,311096,535651,97948,842074,909367,977208,911641,935101,35909,953265,788918,351159,608770,621463,363911,721211,629180,260512,964649,680418,279823,135972,209020,749027,1011440,804309,844406,589419,789938,913389,372213,188533,190968,30267,758671,306642,980999,61599,1047329,1034372,1012552,247242,826099,856570,922953,152856,895746,301388,1023297,962510,678793,1027519,544246,773409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001087s ]