SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539414 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539414 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24405,292268,326615,9072,846474,269747,937134,45241,112502,881842,126107,320871,333408,706324,828510,599113,459256,28277,371248,1028556,882246,205353,589302,641111,435058,926296,26235,521162,650303,8127,629121,263915,396323,556750,55978,114640,131255,690131,859999,849898,415114,829832,628211,1043863,655552,218942,878005,774951,280800,546322,74493,265812,863374,559872,960066,860312,290720,428804,807739,769648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]