SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3992 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3992 [ RunTime:0.002120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527760,202450,447267,655178,99745,831420,1011430,354821,322045,83289,862534,961242,345838,1036981,21871,644095,376036,1016729,311346,644614,47768,284980,133161,315986,778700,898013,11644,530534,917407,478026,753653,195676,684013,866215,760108,965459,862681,292335,396151,484491,139294,312415,272185,711135,779505,472427,340077,442502,780969,316363,199821,383554,872915,951355,32828,198325,999064,1044640,836526,165470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]