SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412935 LIMIT 1 [ RunTime:0.000753s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412935 [ RunTime:0.002935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546418,228788,383996,971542,773599,784297,174026,447110,821238,377010,618825,597889,496167,605779,941243,613302,107484,235064,402507,763214,811048,846580,920961,119868,628271,177703,898562,451389,212232,684028,924397,131188,243622,120377,378617,958416,826276,715321,671614,757338,84203,293068,1043577,872931,263604,343938,178889,1036905,463292,853523,383788,633632,331525,728282,678493,686693,721703,536508,900358,64444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]