SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505916 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505916 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670290,140768,808963,176192,348584,143662,706436,478199,318208,543069,262446,194544,1017795,896075,207291,188960,847639,419582,93163,704484,753838,878450,854561,573088,932248,981118,925004,675682,939265,679589,817973,216359,489077,560321,874241,775287,1018878,659453,546205,625724,458200,222262,672575,935778,503932,693391,104096,1017429,911742,736308,740402,434273,111659,932734,777945,1005408,975866,343499,419986,120962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]