SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040358 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040358 [ RunTime:0.002120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191339,936294,910840,661845,641795,360462,357022,303012,969479,119921,952928,168747,903236,192434,33179,858339,70327,790006,284889,1025760,128523,771112,636008,266720,151716,410197,289813,667631,979507,858496,647045,56096,763728,830589,36123,991077,75762,378171,646151,426419,892011,368432,433637,773828,944366,328197,737945,433768,674161,824874,319634,895691,713954,500975,889956,413368,664317,618885,127222,811808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040358 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040358 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]