SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526799 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526799 [ RunTime:0.002824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003227,681047,836114,201697,72456,1019541,251755,262084,412118,728355,921515,402214,422073,465148,350041,1020567,708901,814751,629344,430716,948433,853262,171475,879407,634176,242590,921852,159760,925784,140910,79237,827988,665517,137476,969227,554281,50256,795552,844915,105466,483548,885712,469900,151365,391825,340236,772154,743742,802796,418777,468445,930094,845048,733563,23239,796532,330371,165849,926998,807670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526799 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526799 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]