SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001838s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418348 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418348 [ RunTime:0.004105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112213,512385,234692,288847,295222,920678,211091,661821,464666,448700,605927,720343,1029918,152844,769394,663543,664977,1035708,419244,744367,400881,317576,629834,974616,872064,369174,962918,156126,170746,447476,107866,964964,916494,457050,593013,1020856,263780,812414,537613,411246,642337,37732,705206,1044552,1041667,219011,957328,152014,216113,323249,470972,1018069,89315,876778,839451,485506,87085,86878,957707,889303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004849s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418348 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418348 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]