SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801881 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801881 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45743,230185,412688,7533,707029,57133,591114,247547,29425,393965,91905,345904,431316,452079,703916,945510,81266,1011627,660459,924232,606878,549572,246924,322156,801510,642769,759603,337344,436959,221191,953346,499671,285634,151612,1029146,548643,67651,141861,1046837,103606,813051,841719,149255,320765,653133,932629,480781,270667,711998,254530,898549,645784,153870,930762,877495,564293,18674,893955,772498,31838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]