SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001969s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38440 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38440 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558451,502598,157491,795972,28857,403440,524571,942897,427623,394646,87186,221197,490787,420946,390251,237496,173377,421692,681182,44740,395308,504422,447085,933730,371222,129397,948594,114852,476862,715330,463620,140455,845508,590131,983232,133348,698538,177295,334600,443127,84278,312106,406713,991320,1026364,304025,667997,535329,555507,403536,633472,428002,475853,29207,761939,531560,131263,183375,37854,616801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]