SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354178 LIMIT 1 [ RunTime:0.002149s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354178 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674314,873863,742767,410412,44655,802469,848563,608957,635233,289120,158106,98590,767685,128957,684280,836914,532368,394943,503424,782524,707310,80647,629173,701526,721298,896175,239192,155325,918744,409861,543218,952416,484450,896045,838857,61967,55089,12568,56611,313036,957239,835870,527607,717805,870315,158525,634933,913868,440887,855325,871500,1036609,691410,843158,331545,968412,946773,228944,811299,827933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]