SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540674 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540674 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130525,158254,851046,922840,577033,708868,463246,692784,19660,427260,162606,175464,671837,445883,94031,237233,247895,435644,520602,641108,23205,86753,553408,1032187,550717,1014337,934938,892227,968885,1040010,775317,136505,1015788,384657,221097,36307,171263,616030,31648,743938,139090,851044,310707,886379,877346,738042,527753,1030889,576137,723182,724098,1034811,1046362,695921,864625,1004835,57950,487692,972410,895028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]