SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393952 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393952 [ RunTime:0.003275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161847,872250,203843,510482,760904,213291,582743,1014227,66654,94129,792576,46530,109121,151814,852950,491141,823207,914781,642167,669120,1044729,828395,756082,808922,445126,410294,391256,1034620,377843,82159,212847,471776,210317,852451,61954,987493,10515,538130,251050,86576,1006395,365761,70512,823084,937870,836152,593914,1001881,116754,327172,435800,291139,37806,331649,762870,534945,244802,180714,66794,879329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003184s ]