SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531860 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531860 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216436,773880,88541,114075,236194,490274,631565,733431,538539,442907,209375,406127,93493,751314,506273,169152,635352,298766,590492,504990,976584,534075,966549,422892,814605,1018551,476831,991758,489844,199193,147102,438762,67825,617741,207659,154207,263739,344030,721309,865040,932931,489553,153323,359415,543935,405763,18949,846683,1036781,895533,433238,938233,442843,252290,496658,198609,588917,805072,109890,804239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]