SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589068 LIMIT 1 [ RunTime:0.002284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589068 [ RunTime:0.003751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176931,753600,771787,16231,278490,927448,218039,922220,159236,131416,394618,288461,987185,1008463,200415,868759,350225,596002,704042,521997,866957,183727,350055,884038,428741,103733,995155,944073,840062,587983,788478,363893,932964,826891,699254,985178,443362,163421,354965,1010976,248971,856906,225772,405396,556097,198457,352836,840737,896404,1027074,123446,278975,527578,620153,277801,223940,593915,184904,204665,624899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000842s ]