SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920136 LIMIT 1 [ RunTime:0.001497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920136 [ RunTime:0.005362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915743,884560,1002409,186836,123390,490047,355683,425401,53938,638305,86012,520530,326299,665784,45659,390412,107613,972102,862257,322421,665415,482068,1029368,746587,252145,424132,892634,319511,735007,541290,7693,466182,190381,1038499,250436,356268,460042,324579,859385,854177,623715,514753,788101,575749,872291,493484,1047973,340324,169744,309644,888530,877993,1018851,715850,46040,894860,58990,786797,861350,458680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001747s ]