SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418053 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418053 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488463,287429,689450,477699,298286,834487,944128,911226,125910,539226,74554,601793,476598,191644,495783,515124,312458,40500,472393,528542,907137,655083,242816,615247,19415,28007,60495,726847,962310,188151,258131,480984,663854,1036303,1039661,747951,247696,235369,21384,831037,720509,769808,413389,971012,941543,836077,953731,893919,962273,677901,345911,1047054,579866,950715,869787,667015,709752,58974,277373,832858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]