SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471294 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471294 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565034,186575,259179,611294,273869,38037,27273,481153,465752,598515,910902,524694,434089,489134,927279,954079,847210,41353,175202,1024318,475394,534523,129152,1031190,512200,208558,479004,581446,604572,669758,634708,542122,884675,237698,889242,348804,868667,977834,929707,211244,697426,2981,35361,941707,567796,862092,642391,780739,293023,82300,330223,444138,345298,578646,777661,884954,186641,680685,1030373,711734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]