SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505392 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505392 [ RunTime:0.003101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69020,955479,192160,730812,566566,602904,249038,512097,344393,604126,85690,374027,273985,905172,836789,466954,741149,384713,291225,661222,855818,181603,182338,152434,287614,673925,911635,229437,482719,388746,992883,982251,569143,198241,449445,99964,611265,442731,688204,941160,568558,216020,626572,393031,25135,595441,547155,515649,653059,248579,797552,503545,283121,771634,590852,214854,887616,47337,1691,240346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001248s ]