SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385404 LIMIT 1 [ RunTime:0.000962s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385404 [ RunTime:0.002389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702313,453348,332579,500520,686225,36465,973666,1043857,53839,592046,772762,760629,658476,184121,179805,393956,549105,429156,710106,165890,215139,901206,106579,920458,130004,390158,739250,176940,550532,944447,597585,340519,540399,203658,355212,181199,973940,805730,297632,187979,6683,821744,814433,18971,518556,291397,948938,418828,775073,421320,868875,842638,99629,910338,38042,74777,253893,534909,523357,98792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002383s ]