SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107811 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107811 [ RunTime:0.002516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546033,169610,235494,832808,434170,697053,837198,827457,750199,98451,123267,699877,956499,114467,858461,275159,86614,961453,877268,664492,421564,787795,600353,667528,974633,255587,158496,42077,243284,570396,930380,394329,840622,194639,720258,797530,829669,123358,863992,490329,62592,247479,235378,719160,299752,58554,133064,909495,198876,209223,480713,454117,1034684,54174,73046,994114,79947,28318,146734,512696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]