SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150521 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150521 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419154,609094,128008,455639,19627,547957,166022,269879,588108,1043057,761415,798319,329187,204628,780375,138363,734069,384488,562975,93165,288752,1014223,606861,71117,732078,51196,674279,497772,268798,342744,845185,451429,553423,816357,851999,774891,83384,535323,156556,474098,97668,978240,637233,623039,618328,275685,969318,960719,518862,174844,631448,596606,499648,233760,359077,537205,353459,413708,520454,386651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]