SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472005 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472005 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194463,668504,74231,628058,399150,988241,1026604,119066,243192,973832,402995,363885,96097,1002580,841062,346932,882435,383673,500447,946198,764050,371009,1010417,35,60583,630690,911992,754079,570876,698363,327778,6834,99370,304242,894557,263335,295443,742594,1003752,489520,771550,722396,348405,18323,428505,131896,434304,625581,1043791,92326,598605,741531,69008,477821,554829,780361,874766,536830,502782,180103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]