SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449499 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449499 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318752,325052,851781,71173,100695,7496,278238,572820,687305,902227,855986,262368,690081,92379,127763,343757,35577,610364,928179,114236,694111,975199,284056,784854,905944,27903,1017515,314739,295417,866160,972728,887017,718932,490256,701787,719077,560464,163616,397857,116511,614974,925779,115064,505596,455283,1008534,254721,962568,22786,586304,506906,821634,477428,495242,934821,603585,422628,589195,1047117,847903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]