SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011608 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011608 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542053,306968,332776,185495,673349,749167,241149,853208,386379,501215,873515,663853,567097,578422,289410,554377,102821,101672,507609,135219,733488,500374,815625,799139,459675,817660,446364,726422,422375,807590,932217,940968,659966,326956,993950,997762,817279,846037,701040,935879,367027,442959,9700,722781,651965,597116,393374,787252,249389,896293,237967,505460,207175,508274,745606,389570,90185,171325,278272,1011038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]