SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316423 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316423 [ RunTime:0.002096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840373,981939,486783,529107,419656,428501,930973,293398,829989,148181,680753,804462,1032527,734457,63386,349972,512429,43150,173307,796269,628023,475300,450003,478145,921173,916158,950805,747994,46041,394124,44083,94694,484583,340190,807624,831920,352623,729096,857529,344476,479680,554604,466169,857191,1012549,372877,840922,219157,149058,106092,189314,22516,776429,373239,730490,592058,450635,366962,377597,204184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]