SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393851 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393851 [ RunTime:0.001479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205716,77188,283634,764993,92928,267114,195310,865994,986175,379917,341728,91410,652758,214980,39883,186793,838783,655141,192709,264887,103773,497788,290354,713060,338018,794480,659634,611472,163137,381225,326260,1026919,251440,271746,793919,956947,934678,954907,304839,185935,5047,212641,555334,612206,143376,889711,311802,414199,570686,540501,652358,890778,599684,671279,674904,271284,820867,419034,328040,993434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]