SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424100 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424100 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512709,247159,963726,224980,467641,158292,34609,918273,754704,61520,873134,781460,736601,701624,243841,625289,434549,221484,795010,681737,853614,1022288,330464,606937,937871,932229,137749,592191,649103,49765,181658,555863,310148,984025,375618,1042720,244700,553156,190173,824544,996359,634888,971943,528971,674367,309636,20489,428960,219374,85253,626345,796976,330884,981146,480827,620572,448299,815183,920290,384722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001622s ]