SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546699 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546699 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551284,615260,101049,97771,795614,886334,704057,544441,414456,928439,828374,286980,1009867,612450,415046,810605,670388,612167,920202,420193,59608,119949,473496,899672,213602,834859,239493,335253,360886,240016,1018693,230572,213946,668032,41816,59329,344077,904816,27762,443622,352114,159096,439096,899219,607565,395929,889394,755106,102901,59067,102489,765758,924959,764843,696885,209963,23166,361064,572416,967040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]