SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504649 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504649 [ RunTime:0.004928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368187,526447,561115,58233,143621,487910,690164,604962,70888,481558,296601,16019,746464,447470,224373,664866,275485,303815,49489,928591,510960,381811,404858,899012,456011,618611,1017641,863364,435703,463303,940738,846978,646088,220162,316727,307335,939165,17170,158559,123860,76287,1006811,225935,565572,156155,833981,997227,222245,774290,731002,193600,776316,436305,92870,8030,817837,808540,323752,515539,241183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504649 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504649 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]