SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004886s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509124 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509124 [ RunTime:0.002647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37080,798648,291778,454369,1026034,678058,413641,671441,436011,817524,481348,608455,409943,864033,662486,1024029,227395,120814,482908,583224,741882,600924,208018,201732,650568,76330,970205,385470,199004,867137,545935,971294,915032,31025,594975,377068,364685,28305,359424,699519,627288,420867,300581,367849,1195,357870,778687,487285,158788,733168,853487,946290,802916,610674,89716,419745,77607,435294,491283,932812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509124 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509124 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]