SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30083 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30083 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735231,961657,1002659,329264,852661,419937,883415,508139,885718,341475,980784,839539,276035,778464,369632,154079,71722,751869,305833,20387,418584,461356,182320,400203,704436,996688,854851,220711,328691,646191,480497,942461,850362,155724,441402,555462,959690,835069,37784,1034075,863967,322150,208119,556169,989686,337109,86761,349801,559939,537322,651125,922361,38332,853327,544935,290456,780499,761495,198475,833212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]