SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511684 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511684 [ RunTime:0.001984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019903,568390,650924,109520,378275,1000137,434240,885699,26686,913997,696150,219027,441829,850668,92978,884277,989462,981622,74368,322973,980679,177752,400326,633105,541725,723109,927858,300267,6491,2021,240762,514544,858617,320609,82474,854086,279376,61295,170029,925135,797503,1020292,1025204,493408,717027,764354,465128,29251,296317,119457,875210,811831,892188,717601,588839,683163,166849,925006,532745,957068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]