SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415927 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415927 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412328,406733,763982,858444,377535,270422,313703,170700,977789,991101,237724,113825,776723,685013,559707,789022,1044182,390197,414331,668685,124663,13277,200664,933160,980637,139904,439904,211834,281201,659378,536749,58785,583961,598141,763058,982894,478496,271105,417313,537376,33109,595402,306754,23779,905222,753164,266117,314326,803651,957093,486265,958553,451361,1017221,642099,1024743,1015142,1021390,898593,175466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]