SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263523 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263523 [ RunTime:0.003944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018063,131617,953656,527594,784353,158412,608723,434613,229366,424935,560771,878098,432067,556044,421011,893411,490953,95382,881769,886344,128531,661537,127769,809610,669518,716217,282670,738245,215613,806084,830919,833469,324260,856613,479218,558159,942935,267453,936591,72649,164687,631438,332393,388667,118649,530880,448652,541617,130967,144780,793711,42297,296703,279448,172007,556910,491208,1020418,945547,145249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000742s ]