SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019038 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019038 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153588,611304,99780,360543,934381,435332,208881,153666,477560,64670,1003621,432683,863422,494774,141621,460410,1000848,434726,603005,693930,825950,887887,641489,824279,351858,873058,631126,490555,899347,497957,693038,219634,625644,175311,737240,904972,364807,797019,972886,593958,740602,493151,381970,310116,883778,798155,144032,584268,19695,10052,36219,556523,266140,258658,357694,26218,198743,192129,621039,849121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]