SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34683 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34683 [ RunTime:0.003068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119524,756101,326968,30276,618480,429030,214864,998402,23962,177612,639932,788393,544439,864049,147883,956190,641666,679799,980832,179703,1023621,748160,249466,966590,939483,78420,922637,468955,1024889,411559,195092,403911,154851,748005,530653,212474,936727,542095,833173,763223,480668,902548,647165,1018313,400611,938002,651518,349450,577469,80402,722990,818786,37996,717823,998348,406574,942323,1040133,733333,841825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001832s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]