SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575733 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575733 [ RunTime:0.003607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602949,380259,161589,878640,565062,183267,482951,434393,98649,3335,270185,81449,638558,270643,467641,308712,341512,240574,596062,449713,501067,946359,976921,181366,173493,723620,438640,247363,575071,810758,574988,143500,793017,111867,1025556,669785,172758,465687,1026361,596522,544190,861835,342572,507442,886489,519606,399419,570642,304371,931486,552445,768981,241875,284855,811370,206528,1030986,683194,717412,437425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000871s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]