SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43301 LIMIT 1 [ RunTime:0.000534s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43301 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406595,88495,69064,985193,49842,111583,1019672,349985,822174,532167,236153,677606,750117,244726,90022,542422,675986,747410,365988,431264,896365,216223,755136,317355,666816,1038637,660338,260864,377037,257583,384888,467162,851317,594833,513055,755186,981694,909227,824669,584861,17234,789540,314073,202324,510990,990854,973043,678039,726025,790795,806118,497328,347704,885622,903979,564244,179613,980077,383295,729419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]