SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501397 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501397 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316880,47728,477930,258437,183170,426219,118539,503192,1005653,435219,929,442668,357852,292288,865887,529483,23786,694192,559412,535272,29773,534207,995355,722631,754468,727210,186488,876972,591663,851929,298471,189372,863219,339305,349661,383594,306734,204260,423217,1000652,671223,580900,953059,2350,887354,405591,638278,687542,438558,503840,628538,605470,483633,739758,492997,522315,855877,356839,822939,860581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501397 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501397 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]