SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486182 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486182 [ RunTime:0.003098s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683250,305960,22330,114923,447365,721996,749537,685129,680126,484479,335380,998146,704349,193541,862402,427502,128680,91259,732302,730805,927630,451014,794822,179081,750238,225929,209984,485784,456169,103603,576668,721223,362167,1048761,665459,363484,788156,463332,205286,549255,186665,415780,241855,663646,34463,329103,156815,597346,751267,352595,262751,881893,117621,399966,372461,113083,994843,714963,148517,324492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]