SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002784s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034516 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034516 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573841,267050,361584,285384,940614,732630,255073,824204,961433,743916,534589,984713,828716,753855,208509,698810,10884,94808,358191,897550,248763,805114,448382,583148,982105,711412,666378,693787,911697,84242,165325,78838,672611,956630,217563,849695,565020,944399,639327,837787,883100,220287,781197,573065,733432,264905,906094,733007,244892,840673,922094,48696,692805,262824,520431,393066,926281,875398,425385,22603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]