SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 67316 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 67316 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429088,675641,196692,689448,803130,912310,502106,434613,322196,601272,490304,137593,773625,169924,858529,43917,113923,790317,253534,323848,224445,430468,909058,772809,290480,377873,791901,752961,699462,690063,1015168,414608,849937,516098,868059,849759,142455,436438,169404,625910,353010,991509,58540,197708,67065,137618,211059,753293,957401,309408,305204,889314,356875,691780,343830,1015311,369722,495935,936224,1039938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 67316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 67316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]