SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517940 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517940 [ RunTime:0.005023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500470,87191,985505,1007985,400351,59755,588112,860771,581900,868058,631033,549964,62639,483650,413059,62715,56132,268501,507966,750334,899514,212774,883836,746629,388763,826765,647025,803299,676796,737572,920733,1012741,482620,759828,992825,187598,378905,613385,781901,244384,372259,703178,170960,992347,299196,490281,274179,463193,163567,346342,926368,230811,717324,1030990,196700,195490,897278,919185,175009,634065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001721s ]