SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522383 LIMIT 1 [ RunTime:0.001162s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522383 [ RunTime:0.002891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546603,15716,926648,150948,299672,304385,193010,428572,415835,626399,156253,989326,331994,365571,756291,547935,760873,1036259,25727,535615,782634,538351,1041271,892680,596715,654486,1040512,467595,812494,141888,253400,942823,88993,834517,85078,1026424,67250,11452,399909,423365,438595,330594,713125,93135,473499,323199,430687,543698,582079,405851,228435,511585,818077,236315,909745,896185,597981,209500,129360,581406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001092s ]