SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002020s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195082 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195082 [ RunTime:0.001459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733716,323352,862154,763542,1047385,916552,588526,680304,116831,435514,1003042,435294,157879,196017,881381,109217,157800,866168,757151,822770,873017,769589,411390,18198,498791,375524,85186,872914,412678,818405,430329,891091,439222,979,946164,374834,766183,98099,850360,871689,921959,848157,576203,607135,505097,256087,751370,374527,196859,856099,892814,78418,829258,285846,327180,540593,183993,384293,687793,762448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]