SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514660 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514660 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648336,126140,803718,537283,467955,17697,16246,945943,338154,188420,785386,475968,804043,943395,927496,92304,186290,282894,843986,854602,995059,353921,173165,358154,669894,66707,110960,439716,713131,590996,987446,531212,488759,248211,705387,181342,93393,916827,841664,1010301,60350,957145,456983,222746,1009564,673191,964991,769801,786716,274539,540629,884966,102639,140561,850293,783886,256399,897547,628299,535760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]